package com.myteam.fugaocrm.sqldb.mapper;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;

import com.myteam.fugaocrm.modle.FgContract;

public interface FgContractMapper {

	@Select("select * from fg_contract where is_delete = 0 and project_id = #{projectId}")
	public FgContract selectByProjectId(Integer projectId);
	
	public void updateOne(FgContract fgContract);
	
	@Insert("INSERT into fg_contract(  project_id, created_user, modified_user, created_date, modified_date, is_delete) "
			+ "VALUES(#{projectId},#{createdUser},#{modifiedUser},#{createdDate},#{modifiedDate},#{isDelete});")
	public void insertOne(FgContract fgContract);
}
